create table lawyers (
                         id uuid DEFAULT gen_random_uuid() PRIMARY KEY,
                         name varchar(20),
                         surname varchar(20),
                         familyName varchar(20),
                         speciality varchar(20)
);

insert into lawyers (name, surname, familyName, speciality)
values ('Абрам', 'Соломонович', 'Иванов', 'FAMILY'),
       ( 'Иван', 'Иваныч','Рабинович','ADMINISTRATIVE');

create table orders (
                        id uuid DEFAULT gen_random_uuid() PRIMARY KEY,
                        speciality varchar(20),
                        description text,
                        author varchar(100),
                        address varchar(100),
                        created timestamp
);
create table lawyers_ads (
                             lawyers_id uuid,
                             address varchar(200),
                             coordinates varchar(25)
);
-- insert into lawyers_ads (lawyers_id, address, coordinates)
-- values (1, '2-й Сыромятнический переулок, 10А, Москва', '55.752648, 37.661347'),
--        (2, '2-й Сыромятнический переулок, 10А, Москва', '55.752648, 37.661347');